home *** CD-ROM | disk | FTP | other *** search

---

/ Developer Source 7 / developer source - volume 7.iso / orinf / sep96 / aronf102.gif

< prev

next >

Graphics Interchange Format  |  1996-11-15  |  54KB  |  1024x768  |  4-bit (15 colors)

Labels: text | screenshot | software | display | computer icon | multimedia software | web page | number
OCR: iSQLab #|SQL Analyzer - File Edit Hints QuickPick Analyze Labs Window Help SQL Lab @071t SELECT/+ INDEX(R FND_CONCURRENT_REQUESTS_N2) 14 INDEX(O FND_ORACLE_USERID_U1) INDEX(P FND_CONCURRENT_PROGRAMS_U1) ORDERED */ R.REQUEST_ID .R.PRIORITY_REQUEST_ID O.CONCURRENT CONFLICT_ SET_ID DECODE(SIGN(SYSDATE-R.REQUESTED_START_DATE),0,DECODE(R.HOLD_FLAG,'Y','N',P.ENABLED_FLAG),1,DECODE(R.HOLD_FLAG,'Y','N',P.ENABLED FROM FND_CONCURRENT_REQUESTS R ,FND_CONCURRENT_PROGRAMS P ,FND_ORACLE_USERID O % WHERE (((PHASE_CODE='R' OR STATUS_CODE="' OR (STATUS_CODE='Q' AND HOLD_FLAG='N'AND REQUESTED_START_DATE <= SYSDATE AND 'Y'=(SELECT ENABLED_FLAG FROM FND_CONCURRENT_PROGRAMS P WHERE P.APPLICATION_ID=R.PROGRAM_APPLICATION ID AND P.CONCURRENT_PROGRAM_ID=R.CONCURRENT_PROGRAM_ID)))AND(SINGLE_THREAD_FLAG='Y'OR(R.QUEUE_METHOD_CODE='B' AND ENFORCE SERIALITY_FLAG='Y')))OR STATUS_CODE=T)AND STATUS_CODE BETWEEN"' AND'W' AND P.APPLICATION_ID=R.PROGRAM_APPLICATION_ID Execute Print Explain Help User Applsys Close - Select Statement Relative Cost=830 L- For Update L- Sort Join L- Filter Merge Join Sort Join L- Merge Join Sort Join DESC 2L - Table Access By Rowid Applsys. fnd_concurrent_requests - Rows: 1487 Tablespace: Test DESC IL Non-unique Index Non-selective Range Scan Applsys. fnd_concurrent_requests_n2 (Status_Code) - Distinct Keys: 4. Rows Per Key: 371.75 Tablespace: Testx Sort Join DESC 4 - Table Access By Rowid Applsys.fnd_concurrent_programs - Rows: 1154 Tablespace: Test DESC 3- Unique Index Range Scan Applsys. fnd_concurrent_programs_u1 (Application_Id, Concurrent_Program_Id) - Distinct Keys: 1154. Rows Per Key: 1. Tablespace: Testx Sort Join DESC 6L- Table Access By Rowid Applsys. fnd_oracle_userid - Rows: 19 Tablespace: Test Ready

---